package com.registerserver.dao;

import java.sql.Date;
import java.sql.SQLException;
import java.util.List;

import com.registerserver.dto.CourseRegisteredInfo;
import com.registerserver.model.Course;

public interface CourseDao {
	
	// get Course information that just registered in semester
	public List<CourseRegisteredInfo> getCoursesInfoRegisteredSInSemester(String studentID,String semester)throws SQLException;
	
	// xem chi tiet thong tin hoc phan cua mon hoc 
	public Course getCourseInfoByID(String courseID) throws SQLException; 
	
	// get all of course in a subject
	public List<Course> getCourseOfSubject(String studentID,String semester,String subjectID) throws SQLException;
	
	// manager add new course 
	public boolean addNewCourse(Course course) throws SQLException;
	
	
	//manager delete course
	public boolean deleteCourse(String courseID) throws SQLException;
	
	public Date getExpiredDate(String courseID) throws SQLException;
	
}
